Publish List to SharePoint Site

In the Address text box, type the URL of the Microsoft Windows SharePoint Services server. You must have permission on the server to publish the list. Select the Link to the new SharePoint list check box if you want to establish a link to the SharePoint list. This enables you to update changes from Microsoft Excel to the SharePoint list when you synchronize.

In the Name text box, type the name that you want for the list. This name for the list must not be an existing name for a list on the SharePoint site.

You can also optionally provide a description for the list in the Description text box.

Step 2 of 2 in the Publish List to SharePoint Site wizard contains data type information for each column in your list. Although you can have multiple data types in the list in Excel, when you publish a list, each column must conform to a single data type that is supported by Windows SharePoint Services.

The Key Cell column indicates the cell address of a cell that determined the data type, except if the first cell in the column determined the data type, then the first cell with a different data type is the key cell. You can use this information to change the data in a cell so that it will conform to the data type that you want the column to be in the SharePoint list.